The Database API > Database API functions > MMDB.getSPParamsAsString()

 

MMDB.getSPParamsAsString()

Availability

Dreamweaver UltraDev 1.0

Description

Gets a comma-delimited string containing the list of parameters that the stored procedure takes.

Arguments

connName, procName

connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.
procName is the name of the stored procedure.

Returns

A comma-delimited string containing the list of parameters that the stored procedure requires. The parameters' names, direction, and data type are included, separated by semicolons (;).

Example

The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast") could return a string of form name startDate;direction:in;datatype:date, salary;direction:in;datatype:integer

Here, the stored procedure, getNewEmployeesMakingAtLeast, has two parameters: startDate and Salary. For startDate, the direction is in and the data type is date. For salary, the direction is in and the data type is date.